home *** CD-ROM | disk | FTP | other *** search
/ AOL File Library: 4,101 to 4,200 / aol-file-protocol-4400-4101-to-4200.zip / AOLDLs / Business Management / VLO_ V98 Virtual Law Office / FREEVL~1.exe / _SETUP.1 / CBCases.qbe < prev    next >
Text File  |  1998-09-18  |  1KB  |  29 lines
  1. Query
  2. ANSWER: :PRIV:CBCases.DB
  3.  
  4. :LOData:Cases.DB | CaseKey                 | 
  5.                  | Check _join3, ~wcasekey | 
  6.  
  7. :LOData:Parties.DB | PL2Cases     | PL2Names     | PRole        | 
  8.                    | Check _join3 | Check _join2 | Check Client | 
  9.  
  10. :LOData:Parties.DB | PTheirReference | 
  11.                    | Check           | 
  12.  
  13. :LOData:Names.DB | NAMEKEY      | Last Name | First Name | Middle Name | 
  14.                  | Check _join2 | Check     | Check      | Check       | 
  15.  
  16. :LOData:Names.DB | Prefix | Suffix | Description | Address Line 1 | 
  17.                  | Check  | Check  | Check       | Check          | 
  18.  
  19. :LOData:Names.DB | Address Line 2 | Address Line 3 | City   | State  | Zip    | 
  20.                  | Check          | Check          | Check  | Check  | Check  | 
  21.  
  22. :LOData:Names.DB | NameType | Date Created | Date Inactive | Inactive Reason | 
  23.                  | Check    | Check        | Check         | Check           | 
  24.  
  25. :LOData:Names.DB | Comments and Notes | Salutation | 
  26.                  | Check              | Check      | 
  27.  
  28. EndQuery
  29.